ODAC

TOraParam Members

TOraParam class overview.

Properties

Name Description

AsArray

Used to specify the value of the parameter when it represents the value of the Oracle array type.

AsBFile

Used to specify the value of the parameter when it represents the value of the Oracle BFile type.

AsBlob (inherited from TDAParam)

Used to set and read the value of the BLOB parameter as string.

AsBLOBLocator

Used to specify the value of a parameter when it represents the value of the BLOB type.

AsBlobRef (inherited from TDAParam)

Used to set and read the value of the BLOB parameter as a TBlob object.

AsCLOBLocator

Used to specify the value of the parameter when it represents the value of CLOB type.

AsCursor

Used to specify the value of the parameter when it represents the value of the PL/SQL REF CURSOR type.

AsFloat (inherited from TDAParam)

Used to assign the value for a float field to a parameter.

AsInteger (inherited from TDAParam)

Used to assign the value for an integer field to the parameter.

AsInterval

Used to specify the parameter value when it represents Oracle 9 interval type.

AsLargeInt (inherited from TDAParam)

Used to assign the value for a LargeInteger field to the parameter.

AsMemo (inherited from TDAParam)

Used to assign the value for a memo field to the parameter.

AsMemoRef (inherited from TDAParam)

Used to set and read the value of the memo parameter as a TBlob object.

AsNumber

Used to specify the value of the parameter when it represents the value of the Oracle internal number type.

AsObject

Used to specify the value of the parameter when it represents the value of the Oracle object type.

AsOraBlob

Used to specify the value of a parameter when it represents the value of the BLOB type.

AsOraClob

Used to specify the value of the parameter when it represents the value of CLOB type.

AsRef

UIsed to specify the value of the parameter when it represents the value of the Oracle reference type.

AsSQLTimeStamp (inherited from TDAParam)

Used to specify the value of the parameter when it represents a SQL timestamp field.

AsString (inherited from TDAParam)

Used to assign the string value to the parameter.

AsTable

Used to specify the value of the parameter when it represents the value of the Oracle nested table type.

AsTimeStamp

Used to sspecify parameter value when it represents Oracle 9 timestamp type.

AsWideString (inherited from TDAParam)

Used to assign the Unicode string value to the parameter.

AsXML

Used to specify the value of the parameter when it represents the value of Oracle SYS.XMLTYPE.

DataType (inherited from TDAParam)

Indicates the data type of the parameter.

IsNull (inherited from TDAParam)

Used to indicate whether the value assigned to a parameter is NULL.

ItemAsDateTime

Used to access a PL/SQL table item as TDateTime by Index.

ItemAsFloat

Used to access a PL/SQL table item as Double by Index.

ItemAsInteger

Used to access a PL/SQL table item as Integer by Index.

ItemAsInterval

Used to access a PL/SQL table item as TOraInterval by Index.

ItemAsString

Used to access a PL/SQL table item as String by Index.

ItemAsTimeStamp

Used to access a PL/SQL table item as TOraTimeStamp by Index.

ItemIsNull

Used to indicate if an item value is Null.

ItemText

Allows to modify data without changing its type.

ItemValue

Used to access the item value as variant.

Length

Used to determine the maximum length of a PL/SQL table parameter.

National

Used to determine whether the parameter is in National charset.

ParamType (inherited from TDAParam)

Used to indicate the type of use for a parameter.

Size (inherited from TDAParam)

Specifies the size of a string type parameter.

Table

Used to determine if the parameter is a PL/SQL table.

Value (inherited from TDAParam)

Used to represent the value of the parameter as Variant.

Methods

Name Description

AssignField (inherited from TDAParam)

Assigns field name and field value to a param.

AssignFieldValue (inherited from TDAParam)

Assigns the specified field properties and value to a parameter.

ItemClear

Assigns a NULL value to a table parameter item.

LoadFromFile (inherited from TDAParam)

Places the content of a specified file into a TDAParam object.

LoadFromStream (inherited from TDAParam)

Places the content from a stream into a TDAParam object.

SetBlobData

Sets the parameter value from the memory buffer.
© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback